package com.example.wanjialei.pojo;


import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import lombok.Data;

import java.sql.Time;
import java.sql.Timestamp;
import java.util.Date;
import java.util.List;
@Data
public class Stock {
    @ExcelProperty("序号")
    private Integer sno;
    @ExcelIgnore
//    @ExcelProperty("提交备货计划日期")
//    @ColumnWidth(25)
    private Timestamp subDate;
    @ExcelProperty("备货计划订单编号")
    @ColumnWidth(25)
    private Integer orderno;
    @ExcelProperty("备货需求时间段")
    @ColumnWidth(20)
    private String period;
    @ExcelProperty("经销商编号")
    @ColumnWidth(20)
    private Integer dno;
    @ExcelProperty("经销商名称")
    @ColumnWidth(20)
    private String dname;
    @ExcelProperty("区域")
    private String area;
    @ExcelProperty("产品编号")
    @ColumnWidth(15)
    private Integer pno;
    @ExcelProperty("产品型号")
    @ColumnWidth(15)
    private String pmodel;
    @ExcelProperty("品类")
    private String category;
    @ExcelProperty("总数量")
    private Integer tnum;
    @ExcelProperty("开票数量")
    @ColumnWidth(15)
    private Double singlePrice;
    @ExcelProperty("总金额")
    private Double tmoney;
    @ExcelProperty("总体积")
    private Double tvolume;
    @ExcelProperty("订单状态")
    @ColumnWidth(15)
    private String dstate;
    @ExcelProperty("状态")
    private String state;
    @ExcelProperty("初审人")
    private String trial;
    @ExcelProperty("复核人")
    private String review;
    @ExcelProperty("申请人")
    private String applicant;
    @ExcelProperty("需缴纳备货保证金")
    @ColumnWidth(25)
    private String needMoney;
    @ExcelProperty("已缴纳备货保证金")
    @ColumnWidth(25)
    private String alreadyMoney;
    @ExcelProperty("备注")
    private String noto;
    @ExcelIgnore
    private List<Dealer> dealers;
    @ExcelIgnore
    private List<Product> products;

    @ExcelIgnore
    private Date      subdatefrom;
    @ExcelIgnore
    private Date      subdateto;

    //分页
    @ExcelIgnore
    private Integer   page = 1;//当前页数
    @ExcelIgnore
    private Integer   rows = 5;//每页显示的件数



}